Leagues

var cid = '' var cGroupname = "" var nStatusCode = 0 var lContinue = true var groupname = request.groupname cursor1 = database.cursor("select * from settings") cursor1.next() week = cursor1.viewweek year = cursor1.viewyear cursor1.close() cursor1 = database.cursor("select * from groupm where groupname = '" + request.groupname + "'") cursor1.next() commissioner = cursor1.commissioner description = cursor1.description comments = cursor1.comments cursor1.close() writeln("") write("

"+request.groupname+" league

") writeln("

") write("Join League
") write("List Leagues
") write("Week "+week+" Standings
") write("Cumulative Standings
") write("Home Page") writeln("

") writeln("

") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("

League Name:	"+request.groupname+"
Commissioner:	"+commissioner+"
Description:	"+description+"
Commissioner Comments:	"+comments+"

") writeln("") writeln("

") writeln("Standings After "+week+" Weeks
") writeln("

") if (!database.connected()) { write("

Error: Database is not available.

") lContinue = false } if (lContinue) { writeln("") write("") write("") write("") write("") write("") write("") write("") cSql = "select year.id,esp,pda,wa,wpa,ups,status,groupd.alias,year.pos" cSql = cSql + " from groupd,year where groupd.groupname = '" cSql = cSql + request.groupname + "'" cSql = cSql + " and (year.year = '" + year + "') and (year.week = '" cSql = cSql + week + "') and (groupd.id = year.id) order by year.pos" cursor = database.cursor(cSql) while (cursor.next()) { // cWkfile = "/fpc/" + year + week + "WK01.htm" lid = "/home/home.htm?id=" + cursor.id + "&&year=" + year cBlank = '' cPda = cBlank + cursor.pda cPda = real(cPda,1) cWa = cBlank + cursor.wa cWa = real(cWa,1) cWpa = cBlank + cursor.wpa cWpa = real(cWpa,1) cUps = cBlank + cursor.ups cUps = real(cUps,2) cStatus = cBlank + cursor.status cStatus = real(cStatus,2) write("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") } write("

ALIAS	POS	ESP	PDA	WA	WPA	UPS	STATUS
" + cursor.alias + "	"+cursor.pos+"	"+cursor.esp+"	"+cPda+"	"+cWa+"	"+cWpa+"	"+cUps+"	"+cStatus+"

") write("") cursor.close() lf = unescape("%0A") }